USE [ERP]
GO

/****** Object:  StoredProcedure [dbo].[SP_CERTIFICATION_TYPES_GET]    Script Date: 11/16/2009 14:37:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_CERTIFICATION_TYPES_GET]
	-- Add the parameters for the stored procedure here	
	@ID  nvarchar(50)
AS
BEGIN
	IF @ID IS NULL 	
		BEGIN
			SELECT [ID] ,[Name]	, ObsoleteFlag FROM CertificationTypes 
		END
	ELSE
		BEGIN
			SELECT [ID] ,[Name]	, ObsoleteFlag  FROM CertificationTypes WHERE [ID] = @ID
		END
END

GO

